﻿CREATE TABLE [dbo].[email_Template] (
    [EmailTemplateId] UNIQUEIDENTIFIER CONSTRAINT [DF_email_Template_EmailTemplateId] DEFAULT (newid()) NOT NULL,
    [Name]            NVARCHAR (256)   NOT NULL,
    [Subject]         NVARCHAR (256)   NOT NULL,
    [Body]            NVARCHAR (MAX)   NOT NULL,
    [IsHtml]          BIT              NOT NULL,
    [Enabled]         BIT              NOT NULL,
    CONSTRAINT [PK_email_Template] PRIMARY KEY CLUSTERED ([EmailTemplateId] ASC),
    CONSTRAINT [IX_email_Template] UNIQUE NONCLUSTERED ([Name] ASC)
);

